Meta-SQL: Towards Practical Meta-Querying
نویسندگان
چکیده
Context Enterprise databases contain not only data but also queries: • view definitions • stored procedures • usage logs • workloads • software engineering Stored as long strings… ! Difficult to query in standard SQL
منابع مشابه
Towards practical meta-querying
We describe a meta-querying system for databases containing queries in addition to ordinary data. In the context of such databases, a meta-query is a query about queries. Representing stored queries in XML, and using the standard XML manipulation language XSLT as a sublanguage, we show that just a few features need to be added to SQL to turn it into a fully-fledged meta-query language. The good...
متن کاملAnalyzing SQL Query Logs using Multi-Relational Graphs
Computer Science 6 (Data Management), FAU Erlangen-Nürnberg {andreas.wahl|richard.lenz}@fau.de Analytical SQL queries are a valuable source of information. They contain expert knowledge that cannot be inferred from schemas or content alone. Consider, for example, data lake scenarios, where relational and semi-structured data sources are combined in a single storage and processing environment. D...
متن کاملVisual Querying for the Semantic Web
Principles of visXcerpt. The Semantic Web aims at enhancing data and service retrieval on the Web using meta-data and automated reasoning. Meta-data on the Semantic Web is heterogeneous. Several formalisms have been proposed. RDF, Topic Maps and OWL, e.g., and some of these formalisms have already a large number of syntactic variants. Like Web data, Web meta-data will be highly distributed. Thu...
متن کاملExtending a UML and OCL Tool for Meta-Modeling: Applications towards Model Quality Assessment
For developing software in a model-driven style, metaand multi-level modeling is currently gaining more and more attention. In this contribution, we propose an approach to extend a two-level modeling tool to three-level modeling by adding a meta-model at the topmost level. Standard OCL does not support reflective constraints, i.e., constraints concerning properties of the model like the depth o...
متن کاملPractical Querying of Temporal Data via OWL 2 QL and SQL: 2011
We develop a practical approach to querying temporal data stored in temporal SQL:2011 databases through the semantic layer of OWL 2 QL ontologies. An interval-based temporal query language (TQL), which we propose for this task, is defined via naturally characterizable combinations of temporal logic with conjunctive queries. This foundation warrants well-defined semantics and formal properties o...
متن کامل